# Prerequisites

Before you can use Amazon Redshift as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

## Driver

* Install and configure the latest Amazon Redshift 64-bit ODBC Driver.

* Install the Amazon Redshift JDBC Driver redshift-jdbc42-2.1.0.30 or later on the Compose machine.

  1. You can download the redshift-jdbc42-2.1.0.30 JAR file from:

     [Amazon Redshift JDBC Driver » 2.1.0.30](https://mvnrepository.com/artifact/com.amazon.redshift/redshift-jdbc42/2.1.0.30)

  2. Copy it to:

     <`Compose`\_Installation\_Folder>\java\jdbc

Information note

The Qlik Compose service needs to be restarted after copying the driver.

## Amazon Redshift Cluster

If you haven't already done so, set up an Amazon Redshift cluster and make sure that following information about your Amazon Redshift Cluster is readily available:

* Amazon Redshift Cluster Name
* Amazon Redshift Cluster Port
* Amazon Redshift User Name and Password
* Amazon Redshift Database Name

## Permissions

Qlik Replicate performs the following operations on the replicated tables within Amazon Redshift:

* SELECT, INSERT, UPDATE and DELETE
* Bulk Load
* CREATE, ALTER, DROP
* CREATE VIEW

If the user is the 'DB Owner', these permissions are in place by default. Otherwise, the user must be granted these permissions to achieve successful replication.

## Port

Make sure that port 5439 (the Amazon Redshift Cluster port) is open for inbound connections from Qlik Compose .